Tabela PhTenderListItem

Definicja tabeli PhTenderListItem

Name

PhTenderListItem

Code

PhTenderListItem

Comment

Elementy list przetargowych


Lista kolumn tabeli PhTenderListItem

Name

Code

TenderListItemID

TenderListItemID

ResourceID

ResourceID

TenderListID

TenderListID

PackID

PackID

PresentationUnitID

PresentationUnitID

Name

Name

AdditionalInfo

AdditionalInfo

UseBrandName

UseBrandName

PriceGross

PriceGross

PriceNet

PriceNet

Quantity

Quantity

ValidityPeriodUnitID

ValidityPeriodUnitID

ValidityPeriodQuantity

ValidityPeriodQuantity


Kolumna TenderListItemID tabeli PhTenderListItem

Definicja kolumny TenderListItemID tabeli PhTenderListItem

Name

TenderListItemID

Code

TenderListItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ResourceID tabeli PhTenderListItem

Definicja kolumny ResourceID tabeli PhTenderListItem

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna TenderListID tabeli PhTenderListItem

Definicja kolumny TenderListID tabeli PhTenderListItem

Name

TenderListID

Code

TenderListID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PackID tabeli PhTenderListItem

Definicja kolumny PackID tabeli PhTenderListItem

Name

PackID

Code

PackID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PresentationUnitID tabeli PhTenderListItem

Definicja kolumny PresentationUnitID tabeli PhTenderListItem

Name

PresentationUnitID

Code

PresentationUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

id jednostki wybranej / prezentowanej uzytkownikowi przy pozycji


Kolumna Name tabeli PhTenderListItem

Definicja kolumny Name tabeli PhTenderListItem

Name

Name

Code

Name

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Nazwa


Kolumna AdditionalInfo tabeli PhTenderListItem

Definicja kolumny AdditionalInfo tabeli PhTenderListItem

Name

AdditionalInfo

Code

AdditionalInfo

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Informacje dodatkowe


Kolumna UseBrandName tabeli PhTenderListItem

Definicja kolumny UseBrandName tabeli PhTenderListItem

Name

UseBrandName

Code

UseBrandName

Data Type

NUMBER(3)

Mandatory

No

Comment

Flaga uzywania nazwy handlowej


Kolumna PriceGross tabeli PhTenderListItem

Definicja kolumny PriceGross tabeli PhTenderListItem

Name

PriceGross

Code

PriceGross

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Cena brutto


Kolumna PriceNet tabeli PhTenderListItem

Definicja kolumny PriceNet tabeli PhTenderListItem

Name

PriceNet

Code

PriceNet

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Cena netto


Kolumna Quantity tabeli PhTenderListItem

Definicja kolumny Quantity tabeli PhTenderListItem

Name

Quantity

Code

Quantity

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Ilosc


Kolumna ValidityPeriodUnitID tabeli PhTenderListItem

Definicja kolumny ValidityPeriodUnitID tabeli PhTenderListItem

Name

ValidityPeriodUnitID

Code

ValidityPeriodUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID jednostki przedzialu czasu waznosci


Kolumna ValidityPeriodQuantity tabeli PhTenderListItem

Definicja kolumny ValidityPeriodQuantity tabeli PhTenderListItem

Name

ValidityPeriodQuantity

Code

ValidityPeriodQuantity

Data Type

NUMBER(10)

Mandatory

No

Comment

Okres waznosci


Lista kluczy tabeli PhTenderListItem

Name

Code

Primary

Key_1

Key_1

X


Klucz Key_1 tabeli PhTenderListItem

Definicja klucza Key_1 tabeli PhTenderListItem

Name

Key_1

Code

Key_1

Primary

Yes

Comment